package com.situ.mall.common.mapper;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.situ.mall.common.entity.MemberAddress;

import com.situ.mall.common.vo.AddressVO;
import com.situ.mall.common.vo.MemberAddressVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lwj
 * @since 2023-09-18
 */
public interface MemberAddressMapper extends BaseMapper<MemberAddress> {

    @Select("select * from member_address where member_id = #{mId} ")
    List<AddressVO> select(Integer mId);

    @Select("select member_address.province,member_address.city,member_address.area,member_address.address,member_address.name,member_address.tel from member_address where id = #{id} and member_id = #{mId}")
    MemberAddressVO cheakAddress(Integer id, Integer mId);
}
